from sqlalchemy import Column
from sqlalchemy.dialects.oracle import VARCHAR2, NUMBER
from sqlalchemy.orm import relationship
from app.db.base import Base

# Scholarship Amount Table
class ScholarshipAmount(Base):
    __tablename__ = 'SCHOLARSHIP_AMOUNT'
    __table_args__ = {'schema': 'COOP_APP'}

    id     = Column(NUMBER, primary_key=True)
    year   = Column(NUMBER(4), nullable=False)
    amount = Column(NUMBER(10, 2), nullable=False)
